﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Employee.aspx.cs" Inherits="Admin" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>Adventure Works Administration Page</title>
    <style>
        a:link{color:#FFFFFF;text-decoration:none}      
        a:visited{color:#FFFFFF;text-decoration:none}     
        a:active{color:##FFFFFF;text-decoration:none} 
        a:hover{color:##FFFFFF;text-decoration:none} 
    </style>
</head>
<body style="font-family: Verdana,Tahoma,Arial; font-size: 10pt;">
    <form id="form1" runat="server">
        <div>
            <table width="100%" cellpadding="3" cellspacing="3">
                <tr>
                    <td align="left" colspan="1">
                    </td>
                    <td align="right" colspan="3">
                        <asp:Image ID="Image1" runat="server" ImageUrl="../Images/AdvWorksLogo.gif" /><br />
                        &nbsp;</td>
                </tr>
            </table>
            <table width="100%" style="background-attachment: scroll; background-image: url(../Images/AdvTop.JPG);
                background-repeat: no-repeat" cellpadding="3" cellspacing="3">
                <tr>
                    <td style="height: 62px">
                        &nbsp;
                    </td>
                </tr>
            </table>
            <table width="100%" border="0" cellpadding="3" cellspacing="3">
                <tr>
                    <td style="background-attachment: scroll; background-image: url(../Images/AdvWorksSideBar.gif);
                        background-repeat: no-repeat; background-position-x: center;" rowspan="3" width="67"
                        height="600">
                    </td>
                    <td rowspan="3" style="background-attachment: scroll; background-image: url(../Images/AdvTable.JPG);
                        background-repeat: repeat-y" width="1%" valign="top">
                        <table border='0' cellspacing='1' cellpadding='1' style='font-family: Verdana,Tahoma,Arial;
                            font-size: 8pt;' width="100%">
                            <tr>
                                <td>
                                </td>
                            </tr>
                            <tr>
                                <td style='border-bottom-style: dotted; border-bottom-width: 1'>
                                </td>
                            </tr>
                            <tr>
                                <td style='font-family: Verdana,Tahoma,Arial; font-size: 8pt;'>
                                </td>
                            </tr>
                            <tr>
                                <td style='border-bottom-style: dotted; border-bottom-width: 1'>
                                </td>
                            </tr>
                            <tr>
                                <td style='font-family: Verdana,Tahoma,Arial; font-size: 8pt;'>
                                </td>
                            </tr>
                            <tr>
                                <td style='border-bottom-style: dotted; border-bottom-width: 1'>
                                </td>
                            </tr>
                            <tr>
                                <td style='font-family: Verdana,Tahoma,Arial; font-size: 8pt;'>
                                </td>
                            </tr>
                        </table>
                    </td>
                    <td align="left" valign="top" rowspan="3">
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AdvWorks %>"
                            SelectCommand="SELECT FirstName, LastName, SalesYTD, SalesLastYear &#13;&#10;FROM Sales.vSalesPerson &#13;&#10;ORDER BY SalesYTD DESC"
                            ProviderName="<%$ ConnectionStrings:AdvWorks.ProviderName %>"></asp:SqlDataSource>
                        <p style="color: Black;">
                            Welcome AdventureWorks Employees!
                        </p>
                        <p style="color: Black;">
                            The table below shows the all your latest sales figures. A case of champagne awaits
                            the most successful sales person at the end of the year. Good luck!
                        </p>
                        <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False"
                            ForeColor="Black">
                            <Columns>
                                <asp:BoundField DataField="FirstName" HeaderText="First Name" />
                                <asp:BoundField DataField="LastName" HeaderText="Last Name" ReadOnly="True" />
                                <asp:BoundField DataField="SalesYTD" DataFormatString="{0:C}" HeaderText="Sales YTD"
                                    ReadOnly="True" />
                                <asp:BoundField DataField="SalesLastYear" DataFormatString="{0:C}" HeaderText="Sales Last Year"
                                    ReadOnly="True" />
                            </Columns>
                        </asp:GridView>
                        &nbsp;</td>
                    <td rowspan="3" valign="top" width="10%">
                    </td>
                </tr>
                <tr style="color: #ffffff">
                </tr>
                <tr>
                </tr>
            </table>
        </div>
    </form>
</body>
</html>
